package com.example.demo.mapper;

import com.example.demo.bean.SInventory;
import java.util.List;
import org.apache.ibatis.annotations.Param;

public interface SInventoryMapper {
    int deleteByPrimaryKey(@Param("productId") Integer productId, @Param("warehouseId") Integer warehouseId);

    int insert(SInventory record);

    SInventory selectByPrimaryKey(@Param("productId") Integer productId, @Param("warehouseId") Integer warehouseId);
    
    List<SInventory> selectByProductId(Integer id);
    
    List<SInventory> selectByWareHouse(Integer id);
    
    List<SInventory> selectAll();

    int updateByPrimaryKey(SInventory record);
    
    List<SInventory> selectByCondition(
    		@Param("productId")Integer productId,
    		@Param("warehouseId")Integer warehouseId
    		);
    
    int batchDelete(int [] warehouseId,int [] productId);
}